create external table jms_ods.rb_damaged_arbitrate
(
  id                        bigint
  ,rfid                      string  comment 'rfid'
  ,report_network_code       string  comment '上报网点编码'
  ,report_network_name       string  comment '上报网点名称'
  ,report_agency_code        string  comment '上报代理区编码'
  ,report_agency_name        string  comment '上报代理区名称'
  ,material_type             bigint  comment '环保物料类型'
  ,status                    bigint  comment '状态'
  ,damage_type               bigint  comment '异常类型'
  ,submit_image              string  comment '上报图片'
  ,appeal_image              string  comment '申诉图片'
  ,appeal_audio              string  comment '申诉音频'
  ,appeal_video              string  comment '申诉视频'
  ,amount                    decimal(10,2)  comment '金额'
  ,duty_network_code         string  comment '责任网点编码'
  ,duty_network_name         string  comment '责任网点名称'
  ,duty_agency_code          string  comment '责任代理区编码'
  ,duty_agency_name          string  comment '责任代理区名称'
  ,is_repair                 bigint  comment '需要维修'
  ,repair_time               timestamp  comment '修复入库时间'
  ,repair_out_time           timestamp  comment '维修出库时间'
  ,repair_into_time          timestamp  comment '维修入库时间'
  ,create_by                 bigint  comment '上报人'
  ,create_by_name            string  comment '上报人名称'
  ,create_time               timestamp  comment '创建时间'
  ,arbitrate_by              bigint  comment '仲裁人'
  ,arbitrate_by_name         string  comment '仲裁名称'
  ,arbitrate_time            timestamp  comment '仲裁名称'
  ,arbitrate_idea            string  comment '仲裁意见'
  ,appeal_create_time        timestamp  comment '申诉上报时间'
  ,appeal_handle_time        timestamp  comment '申诉处理时间'
  ,appeal_idea               string  comment '申诉意见'
  ,appeal_is_valid           bigint  comment '申诉是否有效'
  ,holding_duty_network_code string  comment '裁定责任网点编码'
  ,holding_duty_network_name string  comment '裁定责任网点'
  ,holding_idea              string  comment '裁定意见'
  ,report_remark             string  comment '上报备注'
  ,appeal_by                 bigint  comment '申诉人'
  ,appeal_by_name            string  comment '申诉人名称'
  ,material_details          bigint  comment '循环物料详情 0-承映循环袋 1-极兔循环袋 2-百世循环袋 3-极兔文件袋 4-极兔循环箱'
) comment '循环袋仲裁表'
partitioned by (
  `dt` string comment '创建日期 (yyyy-mm-dd-hh)')
stored as parquet
location
  'hdfs://yl-bg-hdp/dw/hive/jms_ods.db/external/rb_damaged_arbitrate';
